Skip to content

IIS

Install the IIS (Internet Information Services) role on a Windows Server :

  1. Determine the installation type The “Add Roles and Features Wizard” window appears where you have selected:

Role-based or feature-based installation: This is the standard option for installing roles (such as IIS) on a single local or virtual server.

  1. Choose the target server (Server Selection) In this step, the server on which the service will be installed is determined.

A server named IIS-Server.aas.local appears in the list.

We note that the server has a private IP of 10.0.2.15 and that it runs Windows Server 2022 Datacenter.

  1. Add the required IIS features (Add Features) When you select the "Web Server (IIS)" option from the list of roles, a pop-up window appears requesting approval to add the required utilities to manage the server:

Management Tools: Such as "IIS Management Console" that allows you to manage sites later.

Click on Add Features to continue.

  1. Choose Role Services This is the most detailed screen, where the exact properties the web server will operate with are selected:

Common HTTP Features: Includes basic features such as Directory Browsing and error messages.

Security: Important security options such as Basic Authentication and IP and Domain Restrictions have been defined .

FTP Server: Installing a file transfer server (FTP Service) is selected, allowing files to be uploaded and uploaded to and from the server.

Management Tools: To ensure the GUI is installed.

✅ DONE Add Rule

SQL

Download and install Microsoft SQL Server 2022 Express :

Download | LINK

Choose the installation type After running the downloaded file, the installation window appears with three options:

Basic: To install the database with default settings.

Download Media: To download the complete installation files in ISO or CAB format for later installation without the need for the Internet.

Custom: This is the option highlighted in the image

This option allows you to control which features you want to install and change advanced configuration settings.

Media Location: The chosen path appears (Desktop in this case C:\Users\Administrator\Desktop\SQL2022).

And install

SQL Server Installation Center :

Starting the Installation:

The Installation Center interface appears, where "New SQL Server stand-alone installation" is selected to begin a new, standalone installation process.

License Terms:

You must agree to the Microsoft Terms of Use by selecting "I accept the license terms" to proceed.

Microsoft Update:

This option allows the program to check for important security or software updates during installation .

Bypass Azure Extension:

In the image, I have indicated "Bypassed Azure extension." This is an optional step for connecting the database to the Azure cloud and is skipped here.

Feature Selection:

Here, you select the components to install, such as "Database Engine Services" (the core engine) and "SQL Server Replication."

Instance Configuration:

Here, you choose the instance name. In the image, "Named Instance" is selected and named SQLEXPRESS.

Server and Database Settings :

Service Configuration:

Service Accounts:

Define the accounts that will run SQL Server services (such as the database engine and browser).

Collation:

Set language encoding; The picture shows selecting SQL_Latin1_General_CP1_CI_AS (which is the default, which supports Latin and is not case sensitive).

Authentication mode (Database Engine Configuration) :

Mixed Mode is selected.

This allows login using Windows accounts or the SQL Server administrator account (sa account) And Setting a password for the sa account and adding the current user as Administrator appears.

Data Directories:

Specify the locations on the hard drive where database files, logs, and backups will be stored.

Installation End

Installation Progress: A bar showing the status of file installations and ongoing software processes.

Installation Complete: This final screen appears when the process is successful, reporting that all features (such as Database Engine, SQL Browser) have been successfully installed.

OPEN Sql Server Configuration Manager :

The Protocols for SQLEXPRESS section, located under "SQL Server Network Configuration," is selected. This section is for configuring how programs communicate with the SQLEXPRESS database instance.

Network Protocols:

  • The three main protocols are displayed in the right-hand pane, outlined in green:

Shared Memory:

  • Enabled (on), used for communication from the same machine.

Named Pipes:

  • Enabled (on), typically used for communication over local area networks.

TCP/IP:

  • Enabled (on), the most important protocol for enabling network or internet access to the database.

Important Note: Enabling all of these protocols (especially TCP/IP) is a necessary step if you want to access the database from another machine or through an external application.

Steps to download and install the SQL Server Management Studio (SSMS) database management tool and how to connect to the server after installation :

Starting the download of management tools Files folder:

The folder containing the SQL Server core installation file (Setup.exe) appears.

Installation Center: Select the "Install SQL Server Management Tools" option. This link will direct you to download the tool responsible for the graphical interface for managing the database.

Official Download Site :

The official Microsoft page appears with a download button: "Download SQL Server Management Studio 22 installer". This tool is necessary because the engine you previously installed does not have a user interface by default.

Visual Studio Installation Wizard :

The Visual Studio Installer program appears, loading and preparing the essential components required to run the SQL Server Management Studio environment on your Windows system.

Selecting Workloads :

The Feature Selection interface appears, where SSMS Core Components are selected.

At the bottom, an Install button appears to begin the actual installation process, which requires approximately 3.41 GB of space.

Connect to Server :

Window After opening the program, the login window appears.

Server name: Enter the name of the version you previously installed (.\SQLEXPRESS).

Authentication: Select "SQL Server Authentication".

Login/Password: Use the administrator account (sa) and password you set during SQL Server installation.

Final Interface (Object Explorer) :

The final image shows a successful connection. The main program interface opens, and "Object Explorer" appears on the left, containing the database, security, and server settings.

✅ IIS And SQL DONE